
USE [db1859]
GO 

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (1, 'Project setup', 'setup all related issues so work can begin', 1, 4, 1, 43, 29.25, 4, '20090827 16:52:02')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (2, 'Design class model', 'custom inputs,
usercontrols,
business objects
dao methods', 1, 1, 1, 23, 13, 0, '20090827 16:54:00')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (4, 'prepare boxes', NULL, 15, 1, 1, 10, 4, 2, '20090903 05:34:10')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (5, 'burn cds', NULL, 15, 1, 1, 65, 3, 2, '20090903 05:34:24')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (6, 'BUG: systemova chyba v User Story', 'vid US', 18, 1, 1, 5, 0, 4, '20091014 18:49:18')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (7, 'BUG: zobrazovanie stlpcov v tabulkach', 'vid popis US', 26, 1, 1, 5, 0, 4, '20091014 18:52:32')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (8, 'BIG: nejde zadat float do odhadu', 'vid popis US', 32, 1, 1, 5, 0, 4, '20091014 18:55:28')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (9, 'BUG: daily scrum filter nefunguje', 'vid US', 43, 1, 1, 5, 0, 4, '20091014 18:55:58')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (10, 'BUG: enter v textboxoch', 'vid popis US', 52, 1, 1, 5, 0, 4, '20091014 18:56:46')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (11, 'Vytvorit example (dummy) widget', 'Mel by umet nacitat nastaveni, editovat se a podobne', 81, 1, 1, 0, 0, 2, '20091017 18:16:32')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (12, 'Databazovy model', 'este mozno budu zmeny tak ho bude v zavere treba aktualizovat
hlavne aby sme vedeli robit pekny diagram cez "reverse engeneering" existujucej db', 76, 1, 1, 1, 0.5, 2, '20091017 17:50:24')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (13, 'Revizia specifikacie', 'Zachovat rozsah stavajucej (par odrazok)
- spravit z toho nejake ?SRS?
- hlavne vysvetlit co je to progresivna adaptacia sprintov a naprogramovat to :)', 75, 1, 1, 2, 1.25, 4, '20091017 17:50:41')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (14, 'Use Case modely', 'zaktualizovat to co mame uz z prednasky s p. docentom a vyexportovat to do peknych obrazkov (treba na to enterprise architect)', 75, 1, 1, 2, 1.25, 4, '20091017 17:51:30')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (15, 'Okopirovat how-tos z wiki do dokumentacie', 'je to taka druhotna omacka, ktora nam trosku natiahne dokumentaciu', 84, 1, 1, 1, 0, 3, '20091017 18:14:42')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (16, 'Vysperkovat navod ako robit vlastny widget', 'dr. Holanovi to dost vadilo ..', 81, 1, 1, 1, 0, 4, '20091017 17:53:51')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (17, 'Podrobny priebeh projektu', 'Pridat tam aj vysledky uvodnej analyzy. Ktore aplikacie sme skumali s akym vyledkom a tym podporit nase rozhodnutie vypracovat novu aplikaciu.', 82, 1, 1, 5, 0, 2, '20091017 17:58:56')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (19, 'Class diagram', 'doplnit class diagram', 80, 1, 1, 1, 0, 3, '20091017 17:57:02')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (20, 'Uzivatelska dokumentacia - rozsirenie', 'Rozpisat konkretne ako nas system podporuje scrum. Co je konkretne kde a ako to mame super poriesene.', 64, 1, 1, 0, 0, 2, '20091017 18:14:06')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (21, 'Rozsirit navod na vytvoreni widgetu', 'pridat examples, rozsirit... jak pro debily', 81, 1, 1, 0, 0, 2, '20091017 17:54:08')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (22, 'Rozsireni popisu widgetu', 'podrobneji, vice funkcne, co maji delat, jak vypadaji...', 64, 1, 1, 0, 0, 2, '20091017 18:13:51')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (23, 'Kapitola 1 - uvod', 'Popis celeho dokumentu. Co v nom je, naco to je dobre,', 85, 1, 1, 3, 0, 2, '20091024 11:24:12')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (24, 'Kapitola 2 Zoznam riesitelov a ich role', 'Rozpisat ze sme sa  striedali ako scrum master...', 85, 1, 1, 2, 0, 4, '20091024 11:28:13')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (25, 'Kapitola 3 - Uvod do problematiky ', 'Rozpisat scrum. Viac o tom ake ma vyhody a k comu je urceny.', 85, 1, 1, 2, 0, 2, '20091024 11:29:26')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (26, 'Kapitola 4 - popis konkurencneho sw a vyhodz naseho. ', 'Popis analyzy kt sme robili. A zhrnutie jej vysledkov.', 85, 1, 1, 3, 0, 4, '20091024 11:32:02')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (27, 'Kapitola 5 - popis priebehu projektu', 'Miesto tejto kap. by som tam dal zhrnutie user stories na ktorych sme sa  zhodli ze spravime. ', 85, 1, 1, 3, 0, 4, '20091024 11:34:07')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (28, 'Kapitola 6 - Popis datovej vrstvy', NULL, 85, 1, 1, 4, 0, 4, '20091024 11:35:16')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (29, 'Kapitola 7 - Popis navrhu laytoutu', NULL, 85, 1, 1, 4, 0, 4, '20091024 11:36:10')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (30, 'Kapitola 5,5 - Uvod do technickej casti dokumentu', 'High level popis architektury. Podrobnejsie bude popisana v dalsich kapitolach. Vyzdvihnut vyhody a preco sme sa pre nu rozhodli. ', 85, 1, 1, 3, 0, 4, '20091024 11:38:03')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (31, 'Kapitola 8 - SVN rozhranie', NULL, 85, 1, 1, 4, 0, 4, '20091024 11:39:00')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (32, 'Kapitola 9- kriticke zhodnotenie', 'Co sme nestihli, co by sa dalo vylepsit a by sa dalo pridat. Z technickeho pohladu co sa dalo spravit lepsie.', 85, 1, 1, 0, 0, 4, '20091024 11:41:03')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (33, 'Kapitola 10 - Zaver', 'Zhrnutie', 85, 1, 1, 2, 0, 4, '20091024 11:41:44')

INSERT INTO [dbo].[BLI] ([ID], [NAME], [DESCRIPTION], [USER_STORY_ID], [BLI_STATE_ID], [BLI_TYPE_ID], [ESTIMATION], [PROGRESS], [PRIORITY], [CHANGED]) VALUES (34, 'testovanie TYPE selection', NULL, 11, 1, 1, 0, 0, 2, '20091121 11:45:04')

